Release 10.1A: OpenEdge Data Management:
Database Administration

Group Delay (-groupdelay)

Operating system and syntax	UNIX Windows	-groupdelay n
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
DBS	1,000	0	0	1

n

The number of milliseconds a transaction waits before committing.

Use Group Delay (-groupdelay) to increase performance when Delayed BI File Write (-Mf) is set to zero. When the Group Delay is set greater than zero (0), the database engine uses a technique known as Group Commit. When using Group Commit, a transaction spools its end note to the BI buffer and waits a short time until the buffer becomes full and is written to disk, or waits for other transactions to end and store their end notes in the BI buffer so that several transactions are committed by the same synchronous write. In this manner, Group Commit benefits overall performance, although each individual transaction might take slightly longer.